# 从openpyxl库导入load_workbook函数
from openpyxl import load_workbook, Workbook

# 打开【10月员工绩效表】的工作簿，获取活动工作表
performance_wb = load_workbook('./material/10月员工绩效表.xlsx')
performance_ws = performance_wb.active

for row in performance_ws.iter_rows(min_row=2, values_only=True):  # 假设第一行是表头
    staff_id = row[0]
    staff_name = row[1]
    performance = row[3]
    bones = row[4]
    award = performance + bones
    print('工号：{}，姓名：{}，本月奖金为：{}'.format(staff_id, staff_name, award))